package com.tangyee.person_risk_assessment.dao;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class AssessResultDataBaseHelper extends SQLiteOpenHelper {

    private static String name = "AssessResultDataBase.db";
    private static Integer version = 1;

    public AssessResultDataBaseHelper(Context context){
        super(context, name, null, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table AssessResult(" +
                "id integer primary key autoincrement," +
                "QuestionNumber integer," +
                "UserQuestionOptionNumber integer," +
                "QuestionScore interger," +
                "QuestionPoint TEXT)"
        );
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }
}
